package [(${packName})];

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Update;

import [(${beanQualifiedPackName})]Bean;

@Mapper
public class [(${interfaceName})]Mapper {
	
	@Select("SELECT * FROM [(${tableName})]")
	List<[(${beanTypeStr})]Bean> selectList();
	
	@Select("SELECT * FROM [(${tableName})] WHERE id=#{id}")
	[(${beanTypeStr})]Bean selectOneById(int id);
	
	@Delete("DELETE FROM [(${tableName})] WHERE id=#{id}")
	Integer	deleteOneById(int id);
	
	@Insert("INSERT INTO [(${tableName})][(${insert})]")
	Integer insert([(${beanTypeStr})]Bean param);
	
	@Update("UPDATE [(${tableName})] SET [(${update})] WHERE id=#{id}")
	Integer updateById([(${beanTypeStr})]Bean param);
	
}
